Problem Note 54671: The Orphaned Job Metadata tool might remove valid targetTransformation objects
 |  |  |  |  |
The Orphaned Job Component tool incorrectly identifies valid SAS® Data Integration Studio job metadata targetTransformation Set objects as orphaned metadata during the analysis step. The repair step removes the identified job metadata objects.
The Metadata Analyze and Repair tools, which you can access from the Metadata Manager node in SAS® Management Console, enable you to run selected tests on metadata to locate common problems. When it is possible, the tools also repair problems that the analysis identifies. The tools are available with the Analyze and Repair Metadata Batch Tool (sas-analyze-metadata).
The Orphaned Job Component tool checks the metadata repository for metadata that is no longer associated with its job. This tool has several component tools. Each component has a set of rules that are used to determine whether the metadata in question is orphaned from its orginal job. Listed for each component tool is the associations and attributes that will be checked. The object is an orphan if all the listed associations are empty and the attribute values are as specified. One of the rules that determine orphaned Job metadata uses code that looks for source transformations but not a target transformation for Select objects.
The tool assumes that Select objects will be identified as orphans whenever the source transformations are missing. There are some cases where Set objects have target-transformation objects, but no source-transformation objects. If it is identified as an orphan, the valid metadata is removed from the repository.
To prevent the removal of the incorrectly identified orphaned job metadata, it is recommended that you do not run the Orphaned Job Component tool. De-select the tool in the Analyze and Repair Metadata utility.
In addition, when you use the Analyze and Repair Metadata Batch tool (sas-analyze-metadata) do not specify -tool OrphJob.
Note: The Orphaned Job Component tool also runs if you submit the following:
To prevent the Orphan Job Metadata tool from running, submit the following command:
Click the Hot Fix tab in this note to access the hot fix for this issue.
Note: This problem is fixed in the second maintenance release for SAS® 9.4 (TS1M2).
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Management Console | 64-bit Enabled Solaris | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 |
| 64-bit Enabled HP-UX | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| 64-bit Enabled AIX | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Windows Vista for x64 | 9.3_M2 | 9.3 TS1M2 | ||||
| Windows Vista | 9.3_M2 | 9.3 TS1M2 | ||||
| Windows 7 Ultimate x64 | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Ultimate 32 bit | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Professional x64 | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Professional 32 bit | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Home Premium x64 | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Home Premium 32 bit | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Enterprise x64 | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Enterprise 32 bit | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows XP Professional | 9.3_M2 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2012 Std | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2012 R2 Std | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2012 Datacenter | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2008 for x64 | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2008 R2 | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2008 | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2003 for x64 | 9.3_M2 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2003 Standard Edition | 9.3_M2 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 9.3_M2 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 9.3_M2 | 9.3 TS1M2 | ||||
| Microsoft Windows 8.1 Pro 32-bit | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8.1 Pro | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8 Pro x64 | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8 Pro 32-bit | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8 Enterprise x64 | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8 Enterprise 32-bit | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft® Windows® for x64 | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| HP-UX IPF | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Linux | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Linux for x64 | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Solaris for x64 | 9.3_M2 | 9.4_M2 | 9.3 TS1M2 | 9.4 TS1M2 | ||